Value of x | Value of y | x And y |
---|---|---|
The following example is applicable to Crystal syntax:
If {file.CREDIT LIMIT} = 5000 and {file.SALESMAN} = "SP" Then
If the credit limit is 5000 and the salesman is SP (both conditions true), then returns the value in the {file.AMOUNT} field, otherwise return zero.
Returns TRUE, where A = 10, B = 6, and C = 3 (both conditions are true).
Returns FALSE, where A=10, B=6, and C=7 (only one of the two conditions are true).
(A>B) and (A * C - D > E) and (E / D <= B)
Returns TRUE, where A = 7, B = 5, C = 3, D = 2, E = 10 (all three of the conditions are true).
Order of precedence (Basic syntax)
Order of precedence (Crystal syntax)
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |